Release 380: Introduction of external document numbering functionality
Background
Background
In Exact Globe, the standard numbering system that uses ‘Entry number’, ‘Our ref.’ and ‘Your ref’ does not fully meet the local legal and common business requirements for different types of transaction in some countries. In fact, the entry number used for the transaction is taken from the 'item transactions' journal. This cause gaps when the transaction is regenerated or deleted. Furthermore, it is not possible to define alphanumerical prefixes for the numbers.
In some countries, a solid external numbering system is required for most types of transactions. This numbering system must meet legal requirements and most common business rules for the numbering of transactions in the countries. Even more, the numbering specifications such as number format and numbering requirements can differ per legislation or per country. Thus, the numbers should include masks and controlled by a special mechanism of plus one (+1) from the last printed document. The number must be a continuous number without gap and able to reprint. All the numbers need to store in historical table for audit effects by the company or authorities.
For example, when the document is printed incorrectly or damaged, the original document and document number must be voided. The new document must be printed with the next number of the number range, and the previous number will be written into historical table as void status.
To meet the above mentioned legal requirements and business practice, a more flexible external numbering solution based on different types of transactions is needed.
What has been changed
In release 380, a new numbering system has been built in order to provide numbering solution based on type of transaction or a group of transactions. It is now possible to define document numbers that meet legal and common business requirements in a flexible way.
With this new external numbering system, user is possible to define each transaction’s numbering of the following characteristic:
§ Numbers that include masks
§ Numbers that has life cycle frames for each number range
§ Numbers that independent from transaction journal
§ Numbers that can be reused for different transaction type
§ Numbers that has certain condition (if there are any)
§ Compliant with the legal requirements i.e. no gap is allowed
Once the external number range is defined, system will always generate the external number for each of the financial transactions that are part of this range.
The details of the new features are listed below:
1. Concept of external document numbering
2. ‘Use external numbering’ setting
3. Numbering rules maintenance screen
4. Numbering rules overview
5. Recovery mechanism - Consistency check
1. Concept of external document numbering
A new setting has been added for user to define whether the external numbering system is needed or not. This external number is independent from the existing numbering system and it is different from the number that used in the system, e.g. ‘Entry number’, ‘Our ref.’ and ‘Your ref’.
With this new numbering system, user is possible to set up the external numbering range for each or combination of the relevant type(s) of transactions. User is able to define the external numbering range in more flexible way with some conditions defined. The external number will be assigned for those transactions that meet the external numbering range definition. Otherwise, no external number will be assigned and current logic is applied. The external number will be printed in final printed documents if the field is added in the layout.
When a transaction is meet the range definition, an attachment with external number will always be generated and stored in the system regardless a printout is required or not. On the other hands, if the transaction is not met the range definition, generation of the attachment is depends on print option. If printout is required, an attachment is generated without external number. Where else, when printout is not required, no attachment will be generated for the transaction.
The external number is assigned on actual transaction (financial transaction) only and will never assign at any entry level or in trial print stage.
Only predefine transaction will support the external number system. The predefined transactions are as the following (sort by alphabetical order):
§ Cash receipt
§ Collection processing
§ Commission invoice
§ Direct credit note
§ Direct invoice
§ Interbranch transfer fulfillment
§ Interbranch transfer receipt (when ‘Use intermediate warehouse’ is On)
§ Internal fulfillment
§ Internal return
§ Letter of credit
§ Payment
§ Production disassemble fulfillment
§ Production disassemble receipt
§ Production fulfillment
§ Production receipt
§ Purchase receipt (when ‘Receiving slips’ is On)
§ Purchase return
§ RMA receipt
§ RTV return
§ Sales credit note
§ Sales fulfillment
§ Sales invoice
§ Sales return
§ Stock count
During transaction printing, information such as transaction (or reporting) date, transaction type and optional condition values (optional) are required to pass into the external number center process for number retrieving. When the information of the transaction or optional conditions value does not meet in any range definitions, no external number will be assigned to the transaction. More over, external number will not assign to actual transaction that does not involved stock movement (in all logistics application) and should not be copied to a new transaction if user duplicates the transaction from historical data.
In the circumstances, the value passed into the external number center process is determined by each transaction’s process, no validation will be performing on the value.
Optional condition During numbering rules setup; optionally user is possible to further define the condition of each numbering rule. These optional conditions played a role during the generating of the external number within a number range and at the same time its help to speed up data retrieving during reports. The available optional conditions are:
§ Cost center (Enabled when option SE1055 (E-Cost Analysis) is in license)
§ Warehouse
§ Resource
User can defined maximum two optional conditions for each numbering rule. The optional condition selection must be different in case two optional conditions are required. The following are some important notes on passing value into the external number center process:
§ When the optional condition is not in used in the application, no value is required to pass in.
§ When SE1055 (E-Cost Analysis) option is not in license, cost center information is not required to pass in.
§ During single or batch processing which involved multiple optional condition values (e.g. multiple cost center or multiple warehouse), a value comparison is needed:
- If all the multiple values are same, the value is required to pass in and external number should be retrieved when it met the external numbering range definition.
- If more than one value found, no value is required. System will pass in an empty value.
- If an empty value exists on the transaction, system should treat it as one value in the value comparison.
The value of each optional condition is derived based on each transaction and listed as below tables:
1. Cost Center
|
|
Modules |
Functionalities |
Source |
|
Sales invoice process |
Sales invoice |
Sales invoice header |
|
Direct invoice |
Direct invoice header |
|
Sales/Direct credit note |
Credit note header |
|
Sales order process |
Sales order fulfillment |
Sales order header |
|
** Sales order return |
Sales order header (planned return) or original entry’s sales order header (non-planned return) |
|
RMA receipt |
RMA order header |
|
Logistics process |
Interbranch transfer fulfillment |
Cost center of the transaction creator |
|
Interbranch transfer receipt |
Cost center of the transaction creator |
|
Stock count (stock movement <> 0) |
Cost center of the transaction creator |
|
Internal use fulfillment |
Internal use entry’s cost center |
|
Internal use return |
Internal use entry’s cost center |
|
Purchase/Direct receipts |
Purchase order header (purchase receipt) or cost center of representative to the creditor (direct receipt) |
|
|
|
** Purchase return |
Purchase order header (planned return) or original entry’s purchase order header (non-planned return) |
|
RTV return |
RTV order header |
|
** Production order fulfillment (raw materials) |
Production order material line |
|
** Production order receipt (finished goods) |
Production order make item line |
|
** Disassemble production order fulfillment (finished goods) |
Production order make item line |
|
** Disassemble production order receipt (raw materials) |
Production order material line |
|
Cash flow process |
Cash receipt |
Default cost center of the GL linked to cash instrument |
|
Cash payment |
Default cost center of the GL linked to cash instrument |
|
Payment processing |
Cost center of the transaction creator |
|
Collection processing |
Cost center of the transaction creator |
|
Letter of credit |
Cost center of the transaction creator |
Table 1: Source of value for cost center
** When multiple cost centers involved, system will compare the value. If all cost centers have same value,
this value will be used. Otherwise, empty value will be used.
2. Warehouse
|
|
Modules |
Functionalities |
Source |
|
Sales invoice process |
Sales invoice |
Sales invoice header |
|
Direct invoice |
Direct invoice header |
|
Sales/Direct credit note |
Credit note header |
|
Sales order process |
Sales order fulfillment |
Sales order line |
|
Sales order return |
Sales order line (planned return) or original entry’s sales order line (non-planned return) |
|
RMA receipt |
RMA order line |
|
Logistics process |
Interbranch transfer fulfillment |
Warehouse from (issuing warehouse) |
|
Interbranch transfer receipt |
Warehouse to (receiving warehouse) |
|
Stock count (stock movement <> 0) |
Warehouse where the count is performed |
|
Internal use fulfillment |
Internal use entry’s warehouse |
|
Internal use return |
Internal use entry’s warehouse |
|
Purchase/Direct receipts |
Purchase order line (purchase receipt) or receiving warehouse (direct receipt) |
|
|
|
Purchase return |
Purchase order line (planned return) or original entry’s purchase order line (non-planned return) |
|
RTV return |
RTV order line |
|
** Production order fulfillment (raw materials) |
Production order material line |
|
** Production order receipt (finished goods) |
Production order make item line |
|
** Disassemble production order fulfillment (finished goods) |
Production order make item line |
|
** Disassemble production order receipt (raw materials) |
Production order material line |
|
Cash flow process |
Cash receipt |
Not applicable |
|
Cash payment |
Not applicable |
|
Payment processing |
Not applicable |
|
Collection processing |
Not applicable |
|
Letter of credit |
Not applicable |
Table 2: Source of value for warehouse
** When multiple warehouses involved, system will compare the value. If all warehouses have same value,
this value will be used. Otherwise, empty value will be used.
3. Resource
|
|
Modules |
Functionalities |
Source |
|
Sales invoice process |
Sales invoice |
Transaction creator |
|
Direct invoice |
Transaction creator |
|
Sales/Direct credit note |
Transaction creator |
|
Sales order process |
Sales order fulfillment |
Transaction creator |
|
Sales order return |
Transaction creator |
|
RMA receipt |
Transaction creator |
|
Logistics process |
Interbranch transfer fulfillment |
Transaction creator |
|
Interbranch transfer receipt |
Transaction creator |
|
Stock count (stock movement <> 0) |
Transaction creator |
|
Internal use fulfillment |
Transaction creator |
|
Internal use return |
Transaction creator |
|
Purchase/Direct receipts |
Transaction creator |
|
|
|
Purchase return |
Transaction creator |
|
RTV return |
Transaction creator |
|
Production order fulfillment (raw materials) |
Transaction creator |
|
Production order receipt (finished goods) |
Transaction creator |
|
Disassemble production order fulfillment (finished goods) |
Transaction creator |
|
Disassemble production order receipt (raw materials) |
Transaction creator |
|
Cash flow process |
Cash receipt |
Transaction creator |
|
Cash payment |
Transaction creator |
|
Payment processing |
Transaction creator |
|
Collection processing |
Transaction creator |
|
Letter of credit |
Transaction creator |
Table 3: Source of value for resource
Back to top
External number processing
Upon transaction printing process is triggered, individual transaction will passed in all necessary information to the external number center process to obtain an external number. While external number center process will determine the most suitable number range with the condition met and return the first available external number to each printing process. The number will be printed in the document (if the field is added in the layout) and stored in related transaction tables. After that, printing process will invoke the external number center process again to update external number details such as status and the linkage information for traceability.
When batch printing of documents is involved, the external number is assigned one by one to prevent gap in between external numbers. The process is much similar to single document printing, but it is repeating for each transaction. For example, if two documents will be printed, then two external numbers are needed. In other words, it is one external number per actual transaction. In the case the transaction is printed using multiple layouts (collective layouts), one external number will be assigned to the documents.

Image 1: Process flow of retrieving external number
If the information of the transaction type does not meet any of the range definition, the external number will not be assigned. Further more, if the number range for a specific transaction type or a specific optional condition is not defined, it means external number is not required in the document printing. System is carried on the printing process without prompt any warning message. For example, if external number is required on warehouse A only for delivery note, thus number range for other warehouses is not necessary to defined. When delivery note printing on other than warehouse A, no external number will be printed and no warning message will be prompt.
If there is any failure during transaction posting or user manual cancelled a transaction, the external number status should be voided.
There are two possible ways an error message will be launched during midst of the external number retrieving:
1. If user has defined a numbering rule for a transaction type but without any number range linked, the following message will be prompt.

Image 2: Warning message when no number range defined for the active numbering rule
When Yes button is chosen, the document printing is continued without an external number. However, when No button is chosen, it will abort the process and back to the previous screen.
An additional checkbox ‘Don’t ask again’ is checked, the warning dialog box will not be prompt from next time onward. This value is remembered in the system.
2. If the definition is met but all the generated external numbers are fully occupied, the following message will be prompt.

Image 3: Warning message when no available external number
When Yes button is chosen, the document printing is continued without an external number. However, when No button is chosen, it will abort the process and back to the previous screen.
An additional checkbox ‘Don’t ask again’ is checked, the warning dialog box will not be prompt from next time onward. This value is remembered in the system.
Here is the summarized of the external numbering rule creation:
Principles of external numbering rule
1. One transaction type can only linked to one active numbering rule, but one numbering rule can contains multiple transaction types.
2. Within the same numbering rule, it is possible to define multiple number ranges.
3. Uniqueness of the number range is depending on the combination of transaction type and its optional condition’s value for a specific life cycle.
4. Only one active number range can be defined on the same definition within a specific period. It means same date range for a combination of transactions and optional conditions is not possible.
5. The generated external number which take into account of the mask and running number must be unique per transaction type. It must be no overlapping in those numbers.
6. The numbering rule or number range cannot be activated again once it has been set to inactive.
7. In order to have a used transaction type in a new numbering rule, the existing numbering rule must set to inactive first. This is because system does not allow two numbering rule contains same transaction types at the same time.
8. All relevant number range must be inactivated before inactivating the numbering rule.
Back to top
2. ‘Use external numbering’ setting
A new setting has been added in System/General/Settings under Numbers settings tab. This setting is for user to activate or de-activate the external numbering system. This new features has been implemented in all licenses except Exact Compact.

Image 4: New setting ‘Use external numbering’ at Numbers settings
By default this setting is unchecked and current Exact Globe numbering is applied. Once the setting is enabled, an additional menu path is visible at System/Logistics/External numbering when Globe application is restarted.

Image 5: New menu path visible under System/Logistics/External numbering
User has to setup the numbering rules and number range that is applicable to each transaction for document printing.
User is not allowed to unchecked the setting when there is an active numbering rule exists in the administration, a warning message as below is prompt to alert user that all numbering rules have to be set to inactive before de-activate the external numbering system.

Image 6: Warning message when unchecked the ‘Use external numbering’ setting
Back to top
3. Numbering rules maintenance screen When ‘Use external numbering’ setting is enabled, a new menu path is added for numbering rules maintenance via System/Logistics/External numbering/Numbering rules.

Image 7: Numbering rules maintenance screen menu path
When click on this menu path, the selection screen for numbering rules will be launched as below:

Image 8: Numbering rules selection screen
By default, all active numbering rules are shown in this selection screen. The 'Include: Inactive' checkbox will list the additional inactive numbering rule to this selection screen.
|
|
Field |
Description |
|
|
Numbering rule code |
Numbering rule code. The result panel will displayed the numbering rule record based on the value in this field. If the field is left empty, all numbering rule code will be displayed.
User is allowed to define fully or partial of the numbering rule code for fast retrieval. Maximum of 30 alphanumeric characters are allowed. |
|
|
Description |
Numbering rule description. The result panel will displayed the numbering rule record based on the value in this field. If the field is left empty, no filtering will be done.
User is allowed to define fully or partial of the numbering rule description for fast retrieval. Maximum of 60 alphanumeric characters are allowed. |
|
|
Transaction type |
This field accepts transaction type. The result panel will displayed the numbering rule code which belongs to the selected transaction type. A drop down list with predefine transactions is available.
If the field is left empty, the checkbox ‘All’ will automatically checked and all transaction types will be displayed. Otherwise, user is required to select one transaction type from the drop down list. |
|
|
Include: Inactive |
By default this checkbox is unchecked, only active numbering rule code will be displayed. If this checkbox is checked, then all numbering rule code inclusive of inactive status will be shown in the result panel.
The value of this checkbox will be saved, when user re-enters the selection screen, the previous assigned value will be pre-filled. |
Table 4: Fields description for numbering rules selection screen
|
|
Column |
Description |
|
|
Numbering rule code |
Numbering rule code. (Default column) |
|
|
Description |
Numbering rule description. (Default column) |
|
|
Status |
Numbering rule status. Either Active or Inactive. (Default column) |
Table 5: Columns description for numbering rules selection screen
|
|
Action buttons |
Description |
|
|

|
Report button will displayed the defined numbering rules with its details in report format. This is for reference and reporting purpose. It will be enabled when a record is selected in the result panel.
For more details regarding this report, kindly refer to explanation below. |
|
|

|
Logbook button will display a list of changes performed on the selected numbering rule or number range. It contains information like date of modification, modifier full name, old value, new value and etc.
It covers change in transaction type, optional conditions and number range details. This button will be enabled when there is record existing in the logbook.
For more details regarding this logbook, kindly refer to explanation below. |
|
|

|
Delete button allow user to delete the selected numbering rule and it associates number range. This button will only enable when a line is selected and the numbering rule is in active status. It does not support multi lines deletion.
A general deletion warning dialog box pop up with Yes and No action buttons will be prompted when the button is hit.

If Yes button is chosen, it will delete the selected numbering rule. However, when No button is chosen, it will cancel the process.
As long as no external number has been used in the defined numbering rule, the numbering rule is able to delete. Otherwise, warning message will be prompt to alert user on the status.
§ If the selected numbering rule does not contains any number range or the number range has not been used. The numbering rule and it associate number range will be deleted.
§ If the selected numbering rule contains any inactive number range which external number has been used, the following warning message is prompted. No deletion will be done.

§ If the selected numbering rule contains any active number range which external number has been used, the following warning message is prompted. No deletion will be done. However, user is possible to deactivate the number range instead of deleting it.
 |
|
|

|
Open button will open the numbering rules maintenance screen. It will be enabled when a record is selected in the result panel.
For more details regarding numbering rules maintenance screen, kindly refer to document Maintenance of external numbering rules and number range |
|
|

|
New button is always enabled and allowed user to create new numbering rule. The numbering rules maintenance screen will be open once this button is clicked.
For more details regarding numbering rules maintenance screen, kindly refer to document Maintenance of external numbering rules and number range |
|
|

|
Allow user to close the current numbering rules selection screen. |
Table 6: Action buttons description for numbering rules selection screen
The result of this selection screen can be printed to a report format by clicking on Report button. The crystal report will display the information based on the record listed in the selection screen.
Report 1: Numbering rule crystal report
|
|
Column |
Description |
|
|
Section (1) – Report header |
|
|
Report header |
Always show header as ’Numbering rules’. |
|
|
User |
Login user identification number. |
|
|
Company |
Login company code and company name. |
|
|
Report |
Report identification number. |
|
|
Section (2) – Selection data from numbering rule selection screen |
|
|
Numbering rule |
Display numbering rule code, numbering rule description and it status which is selected at the selection screen. |
|
|
Section (3) – Report detail header |
|
|
Transaction type |
Display number rule belonging transaction type(s). |
|
|
Section (4) – Report detail columns (number range) |
|
|
No |
This column displayed the line number. |
|
|
Optional condition |
This column displayed first optional condition for the number range. |
|
|
Optional condition |
This column displayed second optional condition for the number range. |
|
|
Mask |
This column displayed the number range’s predefined mask. |
|
|
Range: Start |
This column displayed the first external number for the number range. |
|
|
Range: End |
This column displayed the last external number for the number range. |
|
|
Last assigned |
This column displayed the last used external number for the number range. |
|
|
Qty. free |
This column displayed the total available free number for the number range. |
|
|
Valid from |
This column displayed the start date of the number range. |
|
|
Valid to |
This column displayed the end date of the number range. |
|
|
Status |
This column displayed number range status. |
Table 7: Column description for numbering rules report
When Logbook button is clicked, an overview with external numbers according to filtering criteria will be shown. This process may take some times depend on the number of records to be retrieved.

Image 9: Logbook screen
|
|
Field |
Description |
|
|
Full name |
Resource's full name of the logged data. The result panel will display the logged data based on the value of the list. |
|
|
Resource |
Resource ID of the logged data. The result panel will display the logged data based on the value of the list. |
|
|
Table name |
Table name of the logged data. The result panel will display the logged data based on the value in the list. |
|
|
Field name |
Field name of the logged data. The result panel will display the logged data based on the value in this field |
| |
Modified.. to.. |
Logged date of the record. The result panel will display the logged data from and to date based on the value in this field. If the field left empty, then all records will be displayed. |
Table 8: Field description for Logbook screen
|
|
Column |
Description |
|
|
Date |
The creation date of the changed. (Default column) |
|
|
Table name |
Table name of the changed field. (Default column)
The table name is prefixed by system, for example:
§ External document numbering rule
§ External number range table |
|
|
Field name |
Field name of the changed field. (Default column)
The field name is prefixed by system, for example:
§ Transaction type
§ Optional condition
§ Start date
§ End date
§ Start number
§ End number |
|
|
Record key |
The log's record unique identifier in database. (Default column)
§ For data in ‘External document numbering rule’, the key will be ‘Numbering rule code + record identifier’
§ For data in ‘External number range table’, the key will be ‘Numbering rule code + line number + record identifier’ |
|
|
Old value |
Original value before changed. (Default column) |
|
|
New value |
New value after changed. (Default column) |
|
|
Full name |
The creator full name of the changed. (Default column) |
Table 9: Column description for Logbook screen
Back to top
4. Numbering rules overview
A new menu path is added for numbering rules overview via System/Logistics/External numbering/External numbers.

Image 10: External numbers overview menu path
Clicking in to this menu path, a selection screen will be shown.

Image 11: External numbers rules selection screen
|
|
Field |
Description |
|
|
Section ‘General’ |
|
|
Numbering rule code |
This field accepts numbering rule code. The overview will filter the external numbers based on numbering rule. If checkbox ‘All’ is checked or the value of this field is empty, then all numbering rule are selected and displayed in the overview.
The browser will show all available numbering rule code (same screen as in Image 5) and user is possible to select from it.
By default, the checkbox ‘All’ is checked when this screen is used at first time. The value of this checkbox will be saved, when user re-enters the selection screen, the previous assigned value will be pre-filled. |
|
|
Number range |
This field is enabled when numbering rule code has value defined. This field accepts number range. The overview will filter the external numbers based on number range. If checkbox ‘All’ is checked or the value of this field is empty, then all external numbers for the selected numbering rule code will be displayed in the overview. By default, the checkbox ‘All’ is checked.
The browser will show all number ranges under a specific numbering rule which defined in field ‘Numbering rule code’. User is possible to select from it.

|
|
|
External number |
This field accepts external number range. The overview will filter an external number or a range of external number. If checkbox 'All' is checked or the value of this field is empty, then all external numbers will be displayed in the overview. By default, the checkbox ‘All’ is checked.
No validation applied when an invalid number is entered. |
|
|
Status: External number |
The overview will filter the external number based on the status. The available value is Active, Void and Used. Either one of the checkbox must be checked; it is possible to select multiple checkboxes.
The value of this checkbox will be saved, when user re-enters the selection screen, the previous assigned value will be pre-filled. |
|
|
Section ‘Extra’ |
|
|
Transaction date |
Only external numbers which valid in the transaction date range will be displayed in the overview. If checkbox ‘All’ is checked or the value of this field is empty, then all external numbers will be displayed without checking on the date range.
By default, the checkbox ‘All’ is checked. |
Table 10: Fields description for numbering rules selection screen
|
|
Action buttons |
Description |
|
|

|
Display button will start external numbers overview. |
|
|

|
Close button allow user to close the current external numbers selection screen. |
Table 11: Action buttons description for external numbers selection screen
When click on Display button, an overview with external numbers according to filtering criteria will be shown. This process may take some times depend on the number of records to be retrieved.

Image 12: External numbers overview screen
|
|
Column |
Description |
|
|
Numbering rule code |
Numbering rule code where the external number belongs to. (Default column) |
|
|
External number |
External number. (Default column) |
|
|
Document type |
Document type originated from the transaction. The document type is defined internally by this external numbering system, not referring to general document type available in CRM. (Default column) |
|
|
Status |
Status of the external number. (Default column) |
|
|
Date |
External number creation date. (Default column) |
|
|
Remark |
Reason for voided external number. (Default column) |
|
|
ID |
Identity number for the external number. It is not default column but can be added via 'Define column' screen. |
|
|
Linked: ID |
Linked identity number for the external number with General ledger transaction table. It is not default column but can be added via 'Define column' screen. |
|
|
Reference: ID |
Reference identity number for the external number with document operation table. It is not default column but can be added via 'Define column' screen. |
Table 12: Columns description for numbering rules selection screen
|
|
Action buttons |
Description |
|
|

|
Refresh button will refresh the overview. This button is always enabled. |
|
|

|
Export button allow user to export the records in the overview to excel spreadsheet. This button is always enabled. |
|
|

|
Attachment button will open the printed document. This button will only be enabled when a single ‘Used’ external number is selected and will be disabled if no line or multiple lines is/are selected. |
|
|

|
Our ref. button will open the transaction window, it shows the transaction details. This button will only be enabled when a single ‘Used’ external number is selected and will be disabled if no line or multiple lines is/are selected. |
|
|

|
Remark button allow user to enrich the information for voided external number. This button will only be enabled when ‘Void’ external number(s) is/are selected.

User may put any remarks or reason for the voided external number(s). Multiple select a few ‘Void’ external numbers for remark entering is allowed.
If the selected external number has existing value in the remark column, system will append the new remark from the last value. |
|
|

|
Open button will open the document in document browser. This button will only be enabled when a single ‘Used’ external number is selected and will be disabled if no line or multiple lines is/are selected. |
|
|

|
Close button allow user to close the current external numbers overview screen. This button is always enabled. |
Table 13: Action buttons description for external numbers selection screen
The result of the overview can be exported to excel by clicking on Export button:

Report 2: External numbers excel report Back to top
5. Recovery mechanism - Consistency check
A new consistency check has been added under Logistics consistency check via System/Checks/Diagnose. It is used to track the healthiness of the linkage between General Ledger Transaction and External Number Details table.
It is visible under <Simple> and <Advanced> mode regardless the setting ‘Use external numbering’ is on or off. When the setting ‘Use external numbering’ is turned off, no action will be performed for this check.

Image 13: New consistency check for external numbers
Details information is available when there is any incomplete linkage discovered by this check:

Image 14: Consistency details screen for Comparison of external numbers against financial transactions
|
|
Column |
Description |
|
|
Transaction type |
Transaction type |
|
|
Transaction sub type |
Transaction sub type |
|
|
Order number |
Order number |
|
|
Our ref. |
Our reference |
|
|
Your ref. |
Your reference |
|
|
Description |
Transaction description |
|
|
External number |
External number |
|
|
Created date |
Created date of the transaction |
|
|
Created by |
Creator of the transaction |
|
|
Modified date |
Last modified date for the transaction |
|
|
Modified by |
Last modifier for the transaction |
Table 14: Columns description for numbering rules selection screen
System will repair all incorrect linkage in External Number Details table with reference to General Ledger Transaction table which the external number has been assigned to actual transactions.
Any missing records in either General Ledger Transaction table or External Number Details table will not be covered and no update or changes would be done on the document number details status field.
Back to top
IMPORTANT: 1. Any adjustment made to the transaction line via analytical accounting will be responsibility of the user.
2. Any form of voiding or deleting the actual transaction will not affect external number. It is only influences on the actual transaction itself.
3. No changes made on XML, Building blocks, Pick-IT, Sales invoice (advanced invoice), Project, Service management, Assets, Human resource, Payroll, CRM, Excel add-in, Quotation, Financials (opening balance, bank/cash/sales/general journal) and Logistics (location transfer, production completion, stock (re)valuation, stock allocation, receipt correction) areas.
Related documents
Release 380: External Number in Invoice
Release 380: External numbering for cash flow documents
Release 380: External numbering in financial reporting
Release 380: External numbering in Logistics areas
|